﻿namespace ExamV5
{
    using System;
    using System.Configuration;
    using System.Data;
    using System.Data.SqlClient;
    using System.Web.Security;
    using System.Web.UI;

    public class FrmOtherRegUser : Page
    {
        private PublicFun publicFun_0 = new PublicFun();

        private void method_0(string string_0)
        {
            string str = "";
            string str2 = "";
            string str3 = "";
            string str4 = "";
            string str5 = "";
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString);
            connection.Open();
            SqlCommand command = new SqlCommand("select ExamName,PaperStatus,RubricDist,SubjectID,SubjectName,PaperDiff,ExamTime,ID,PaperStatus,LastWorkName from PaperInfo where Convert(datetime,PaperEndTime)>getdate() and LastJoin='Y'", connection);
            SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
            while (reader.Read())
            {
                int num;
                string[] strArray;
                string str7;
                string str8;
                string str9;
                str = reader["RubricDist"].ToString();
                str2 = reader["SubjectID"].ToString();
                reader["SubjectName"].ToString();
                str3 = reader["PaperDiff"].ToString();
                str4 = reader["PaperStatus"].ToString();
                reader["ExamName"].ToString();
                str5 = reader["ExamTime"].ToString();
                if (reader["LastWorkName"].ToString().Replace("##", "").Trim() == "")
                {
                    if (this.publicFun_0.GetValues("select PaperID from ExamUser where Flag='A' and  UserCode='" + string_0 + "' and PaperID=" + reader["ID"].ToString(), "PaperID") != "")
                    {
                        strArray = str2.Split(new char[] { ',' });
                        str9 = "";
                        num = 0;
                        while (num < strArray.Length)
                        {
                            if (str9.Trim().Length != 0)
                            {
                                str9 = str9 + " or SubjectID='" + strArray[num].Trim() + "'";
                            }
                            else
                            {
                                str9 = "SubjectID='" + strArray[num].Trim() + "'";
                            }
                            num++;
                        }
                        try
                        {
                            str7 = "";
                            if (!(this.publicFun_0.GetValues("select PaperID from PaperRule where PaperID=" + reader["ID"].ToString(), "PaperID") != ""))
                            {
                                str7 = "A";
                            }
                            else
                            {
                                str7 = "B";
                            }
                            if (str7.Trim() == "A")
                            {
                                this.method_1(string_0, reader["ID"].ToString(), str.Trim(), str9, str3, str4, str5);
                            }
                            if (str7.Trim() == "B")
                            {
                                str8 = "select ID from RubricInfo where IsDel='N' and Flag='" + str4 + "' and ISCheck='N'";
                                this.method_2(string_0, reader["ID"].ToString(), str8, str, str5);
                            }
                        }
                        catch
                        {
                        }
                    }
                }
                else
                {
                    string values = this.publicFun_0.GetValues("select Worker from UserInfo where UserCode='" + string_0 + "'", "Worker");
                    if ((reader["LastWorkName"].ToString().IndexOf("#" + values + "#") != -1) && (this.publicFun_0.GetValues("select PaperID from ExamUser where  Flag='A' and  UserCode='" + string_0 + "' and PaperID=" + reader["ID"].ToString(), "PaperID") != ""))
                    {
                        strArray = str2.Split(new char[] { ',' });
                        str9 = "";
                        for (num = 0; num < strArray.Length; num++)
                        {
                            if (str9.Trim().Length != 0)
                            {
                                str9 = str9 + " or SubjectID='" + strArray[num].Trim() + "'";
                            }
                            else
                            {
                                str9 = "SubjectID='" + strArray[num].Trim() + "'";
                            }
                        }
                        try
                        {
                            str7 = "";
                            if (!(this.publicFun_0.GetValues("select PaperID from PaperRule where PaperID=" + reader["ID"].ToString(), "PaperID") != ""))
                            {
                                str7 = "A";
                            }
                            else
                            {
                                str7 = "B";
                            }
                            if (str7.Trim() == "A")
                            {
                                this.method_1(string_0, reader["ID"].ToString(), str.Trim(), str9, str3, str4, str5);
                            }
                            if (str7.Trim() == "B")
                            {
                                str8 = "select ID from RubricInfo where IsDel='N' and Flag='" + str4 + "' and ISCheck='N'";
                                this.method_2(string_0, reader["ID"].ToString(), str8, str, str5);
                            }
                            continue;
                        }
                        catch
                        {
                            continue;
                        }
                    }
                }
            }
            reader.Close();
            command.Dispose();
            connection.Close();
            connection.Dispose();
        }

        private void method_1(string string_0, string string_1, string string_2, string string_3, string string_4, string string_5, string string_6)
        {
            string str = "#";
            string str2 = "#";
            string str3 = "#";
            string str4 = "#";
            string str5 = "#";
            string str6 = "#";
            string str7 = "#";
            string str8 = "#";
            string str9 = "#";
            Random random = new Random();
            bool flag = true;
            string[] strArray = string_2.Split(new char[] { '#' });
            string str10 = string_5;
            string strSql = "select ID from RubricInfo where IsDel='N' and Flag='" + str10 + "' and ISCheck='N' and (" + string_3 + ")";
            SqlConnection selectConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString);
            DataSet dataSet = new DataSet();
            if (Convert.ToInt32(strArray[0]) > 0)
            {
                int num25 = Convert.ToInt32(strArray[0]);
                SqlDataAdapter adapter9 = new SqlDataAdapter(strSql + " and RubricType='A'", selectConnection);
                adapter9.Fill(dataSet, "AExamData");
                int count = dataSet.Tables["AExamData"].Rows.Count;
                while (flag)
                {
                    if (num25 == 0)
                    {
                        break;
                    }
                    int num27 = random.Next(count);
                    string str30 = dataSet.Tables["AExamData"].Rows[num27]["ID"].ToString() + "#";
                    if (str.IndexOf("#" + str30, 0) == -1)
                    {
                        str = str + str30;
                        num25--;
                    }
                }
                dataSet.Tables.Clear();
                adapter9.Dispose();
            }
            if (Convert.ToInt32(strArray[1]) > 0)
            {
                int num22 = Convert.ToInt32(strArray[1]);
                SqlDataAdapter adapter8 = new SqlDataAdapter(strSql + " and RubricType='B'", selectConnection);
                adapter8.Fill(dataSet, "BExamData");
                int maxValue = dataSet.Tables["BExamData"].Rows.Count;
                while (flag)
                {
                    if (num22 == 0)
                    {
                        break;
                    }
                    int num24 = random.Next(maxValue);
                    string str28 = dataSet.Tables["BExamData"].Rows[num24]["ID"].ToString() + "#";
                    if (str2.IndexOf("#" + str28, 0) == -1)
                    {
                        str2 = str2 + str28;
                        num22--;
                    }
                }
                dataSet.Tables.Clear();
                adapter8.Dispose();
            }
            if (Convert.ToInt32(strArray[2]) > 0)
            {
                int num19 = Convert.ToInt32(strArray[2]);
                SqlDataAdapter adapter7 = new SqlDataAdapter(strSql + " and RubricType='C'", selectConnection);
                adapter7.Fill(dataSet, "CExamData");
                int num20 = dataSet.Tables["CExamData"].Rows.Count;
                while (flag)
                {
                    if (num19 == 0)
                    {
                        break;
                    }
                    int num21 = random.Next(num20);
                    string str26 = dataSet.Tables["CExamData"].Rows[num21]["ID"].ToString() + "#";
                    if (str3.IndexOf("#" + str26, 0) == -1)
                    {
                        str3 = str3 + str26;
                        num19--;
                    }
                }
                dataSet.Tables.Clear();
                adapter7.Dispose();
            }
            if (Convert.ToInt32(strArray[3]) > 0)
            {
                int num16 = Convert.ToInt32(strArray[3]);
                SqlDataAdapter adapter6 = new SqlDataAdapter(strSql + " and RubricType='D'", selectConnection);
                adapter6.Fill(dataSet, "DExamData");
                int num17 = dataSet.Tables["DExamData"].Rows.Count;
                while (flag)
                {
                    if (num16 == 0)
                    {
                        break;
                    }
                    int num18 = random.Next(num17);
                    string str24 = dataSet.Tables["DExamData"].Rows[num18]["ID"].ToString() + "#";
                    if (str4.IndexOf("#" + str24, 0) == -1)
                    {
                        str4 = str4 + str24;
                        num16--;
                    }
                }
                dataSet.Tables.Clear();
                adapter6.Dispose();
            }
            if (Convert.ToInt32(strArray[4]) > 0)
            {
                int num13 = Convert.ToInt32(strArray[4]);
                SqlDataAdapter adapter5 = new SqlDataAdapter(strSql + " and RubricType='E'", selectConnection);
                adapter5.Fill(dataSet, "EExamData");
                int num14 = dataSet.Tables["EExamData"].Rows.Count;
                while (flag)
                {
                    if (num13 == 0)
                    {
                        break;
                    }
                    int num15 = random.Next(num14);
                    string str22 = dataSet.Tables["EExamData"].Rows[num15]["ID"].ToString() + "#";
                    if (str5.IndexOf("#" + str22, 0) == -1)
                    {
                        str5 = str5 + str22;
                        num13--;
                    }
                }
                dataSet.Tables.Clear();
                adapter5.Dispose();
            }
            if (Convert.ToInt32(strArray[5]) > 0)
            {
                int num10 = Convert.ToInt32(strArray[5]);
                SqlDataAdapter adapter4 = new SqlDataAdapter(strSql + " and RubricType='F'", selectConnection);
                adapter4.Fill(dataSet, "FExamData");
                int num11 = dataSet.Tables["FExamData"].Rows.Count;
                while (flag)
                {
                    if (num10 == 0)
                    {
                        break;
                    }
                    int num12 = random.Next(num11);
                    string str20 = dataSet.Tables["FExamData"].Rows[num12]["ID"].ToString() + "#";
                    if (str6.IndexOf("#" + str20, 0) == -1)
                    {
                        str6 = str6 + str20;
                        num10--;
                    }
                }
                dataSet.Tables.Clear();
                adapter4.Dispose();
            }
            if (Convert.ToInt32(strArray[6]) > 0)
            {
                int num7 = Convert.ToInt32(strArray[6]);
                SqlDataAdapter adapter3 = new SqlDataAdapter(strSql + " and RubricType='G'", selectConnection);
                adapter3.Fill(dataSet, "GExamData");
                int num8 = dataSet.Tables["GExamData"].Rows.Count;
                while (flag)
                {
                    if (num7 == 0)
                    {
                        break;
                    }
                    int num9 = random.Next(num8);
                    string str18 = dataSet.Tables["GExamData"].Rows[num9]["ID"].ToString() + "#";
                    if (str7.IndexOf("#" + str18, 0) == -1)
                    {
                        str7 = str7 + str18;
                        num7--;
                    }
                }
                dataSet.Tables.Clear();
                adapter3.Dispose();
            }
            if (Convert.ToInt32(strArray[7]) > 0)
            {
                int num4 = Convert.ToInt32(strArray[7]);
                SqlDataAdapter adapter2 = new SqlDataAdapter(strSql + " and RubricType='H'", selectConnection);
                adapter2.Fill(dataSet, "HExamData");
                int num5 = dataSet.Tables["HExamData"].Rows.Count;
                while (flag)
                {
                    if (num4 == 0)
                    {
                        break;
                    }
                    int num6 = random.Next(num5);
                    string str16 = dataSet.Tables["HExamData"].Rows[num6]["ID"].ToString() + "#";
                    if (str8.IndexOf("#" + str16, 0) == -1)
                    {
                        str8 = str8 + str16;
                        num4--;
                    }
                }
                dataSet.Tables.Clear();
                adapter2.Dispose();
            }
            if (Convert.ToInt32(strArray[8]) > 0)
            {
                int num = Convert.ToInt32(strArray[8]);
                SqlDataAdapter adapter = new SqlDataAdapter(strSql + " and RubricType='I'", selectConnection);
                adapter.Fill(dataSet, "IExamData");
                int num2 = dataSet.Tables["IExamData"].Rows.Count;
                while (flag)
                {
                    if (num == 0)
                    {
                        break;
                    }
                    int num3 = random.Next(num2);
                    string str14 = dataSet.Tables["IExamData"].Rows[num3]["ID"].ToString() + "#";
                    if (str9.IndexOf("#" + str14, 0) == -1)
                    {
                        str9 = str9 + str14;
                        num--;
                    }
                }
                dataSet.Tables.Clear();
                adapter.Dispose();
            }
            dataSet.Clear();
            dataSet.Dispose();
            selectConnection.Dispose();
            string values = this.publicFun_0.GetValues("select top 1 RubricJ from PaperData where PaperID=" + string_1, "RubricJ");
            if (!(values != ""))
            {
                values = "";
            }
            else
            {
                values = values.Trim().Replace("_", "#");
            }
            if (str.Length <= 1)
            {
                str = "";
            }
            else
            {
                str = str.Substring(1);
            }
            if (str2.Length <= 1)
            {
                str2 = "";
            }
            else
            {
                str2 = str2.Substring(1);
            }
            if (str3.Length <= 1)
            {
                str3 = "";
            }
            else
            {
                str3 = str3.Substring(1);
            }
            if (str4.Length > 1)
            {
                str4 = str4.Substring(1);
            }
            else
            {
                str4 = "";
            }
            if (str5.Length <= 1)
            {
                str5 = "";
            }
            else
            {
                str5 = str5.Substring(1);
            }
            if (str6.Length > 1)
            {
                str6 = str6.Substring(1);
            }
            else
            {
                str6 = "";
            }
            if (str7.Length <= 1)
            {
                str7 = "";
            }
            else
            {
                str7 = str7.Substring(1);
            }
            if (str8.Length <= 1)
            {
                str8 = "";
            }
            else
            {
                str8 = str8.Substring(1);
            }
            if (str9.Length <= 1)
            {
                str9 = "";
            }
            else
            {
                str9 = str9.Substring(1);
            }
            strSql = "update ExamUser set LastTime='" + string_6 + "',Flag='A',IsSave=0,StartTime='',EndTime='',GetOldCountFen=0,GetCountFen=0,LoginIP='' where UserCode='" + string_0 + "' and PaperID=" + string_1;
            strSql = strSql + ";update PaperData set RubricS='" + str + "',RubricD='" + str2 + "',RubricB='" + str3 + "',RubricF='" + str4 + "',RubricA='" + str5 + "',RubricC='" + str6 + "',RubricT='" + str7 + "',RubricAN='" + str8 + "',RubricO='" + str9 + "',RubricJ='" + values + "' where PaperID='" + string_1 + "' and UserCode='" + string_0 + "'";
            strSql = strSql + ";delete from CheckPaper where  UserCode='" + string_0 + "' and PaperID=" + string_1;
            this.publicFun_0.ExecuteSql(strSql);
        }

        private void method_2(string string_0, string string_1, string string_2, string string_3, string string_4)
        {
            SqlDataReader reader;
            SqlCommand command;
            SqlConnection connection2;
            string str14;
            int count;
            int num3;
            string str = "#";
            string str2 = "#";
            string str3 = "#";
            string str4 = "#";
            string str5 = "#";
            string str6 = "#";
            string str7 = "#";
            string str8 = "#";
            string str9 = "#";
            Random random = new Random();
            bool flag = true;
            string str10 = "";
            int num = 0;
            string[] strArray = string_3.Split(new char[] { '#' });
            string strSql = "";
            string connectionString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
            SqlConnection selectConnection = new SqlConnection(connectionString);
            DataSet dataSet = new DataSet();
            if (Convert.ToInt32(strArray[0]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='A'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter9 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter9 = new SqlDataAdapter(string_2 + "  and (" + str10 + ")", selectConnection);
                    adapter9.Fill(dataSet, "AExamData");
                    count = dataSet.Tables["AExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["AExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str.IndexOf("#" + str14, 0) == -1)
                        {
                            str = str + str14;
                            num--;
                        }
                    }
                    adapter9.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[1]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='B'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter8 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter8 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter8.Fill(dataSet, "BExamData");
                    count = dataSet.Tables["BExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["BExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str2.IndexOf("#" + str14, 0) == -1)
                        {
                            str2 = str2 + str14;
                            num--;
                        }
                    }
                    adapter8.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[2]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='C'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter7 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter7 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter7.Fill(dataSet, "CExamData");
                    count = dataSet.Tables["CExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["CExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str3.IndexOf("#" + str14, 0) == -1)
                        {
                            str3 = str3 + str14;
                            num--;
                        }
                    }
                    adapter7.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[3]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='D'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter6 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter6 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter6.Fill(dataSet, "DExamData");
                    count = dataSet.Tables["DExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["DExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str4.IndexOf("#" + str14, 0) == -1)
                        {
                            str4 = str4 + str14;
                            num--;
                        }
                    }
                    adapter6.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[4]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='E'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter5 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter5 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter5.Fill(dataSet, "EExamData");
                    count = dataSet.Tables["EExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["EExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str5.IndexOf("#" + str14, 0) == -1)
                        {
                            str5 = str5 + str14;
                            num--;
                        }
                    }
                    adapter5.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[5]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='F'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter4 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter4 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter4.Fill(dataSet, "FExamData");
                    count = dataSet.Tables["FExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["FExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str6.IndexOf("#" + str14, 0) == -1)
                        {
                            str6 = str6 + str14;
                            num--;
                        }
                    }
                    adapter4.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[6]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='G'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter3 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter3 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter3.Fill(dataSet, "GExamData");
                    count = dataSet.Tables["GExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["GExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str7.IndexOf("#" + str14, 0) == -1)
                        {
                            str7 = str7 + str14;
                            num--;
                        }
                    }
                    adapter3.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[7]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='H'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter2 = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter2 = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter2.Fill(dataSet, "HExamData");
                    count = dataSet.Tables["HExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["HExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str8.IndexOf("#" + str14, 0) == -1)
                        {
                            str8 = str8 + str14;
                            num--;
                        }
                    }
                    adapter2.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            if (Convert.ToInt32(strArray[8]) > 0)
            {
                connection2 = new SqlConnection(connectionString);
                connection2.Open();
                command = new SqlCommand("select RuleValue,GetNum from PaperRule where PaperID=" + string_1 + " and RubricType='I'", connection2);
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                SqlDataAdapter adapter = null;
                while (reader.Read())
                {
                    str10 = reader["RuleValue"].ToString().Trim().Replace('‘', '\'').Replace("’", "'");
                    num = Convert.ToInt32(reader["GetNum"].ToString().Trim());
                    adapter = new SqlDataAdapter(string_2 + " and (" + str10 + ")", selectConnection);
                    adapter.Fill(dataSet, "IExamData");
                    count = dataSet.Tables["IExamData"].Rows.Count;
                    while (flag)
                    {
                        if (num == 0)
                        {
                            break;
                        }
                        num3 = random.Next(count);
                        str14 = dataSet.Tables["IExamData"].Rows[num3]["ID"].ToString() + "#";
                        if (str9.IndexOf("#" + str14, 0) == -1)
                        {
                            str9 = str9 + str14;
                            num--;
                        }
                    }
                    adapter.Dispose();
                    dataSet.Tables.Clear();
                }
                reader.Close();
                command.Dispose();
                connection2.Close();
                connection2.Dispose();
            }
            dataSet.Clear();
            dataSet.Dispose();
            selectConnection.Close();
            selectConnection.Dispose();
            string values = this.publicFun_0.GetValues("select top 1 RubricJ from PaperData where PaperID=" + string_1, "RubricJ");
            if (values != "")
            {
                values = values.Trim().Replace("_", "#");
            }
            else
            {
                values = "";
            }
            if (str.Length <= 1)
            {
                str = "";
            }
            else
            {
                str = str.Substring(1);
            }
            if (str2.Length <= 1)
            {
                str2 = "";
            }
            else
            {
                str2 = str2.Substring(1);
            }
            if (str3.Length > 1)
            {
                str3 = str3.Substring(1);
            }
            else
            {
                str3 = "";
            }
            if (str4.Length <= 1)
            {
                str4 = "";
            }
            else
            {
                str4 = str4.Substring(1);
            }
            if (str5.Length <= 1)
            {
                str5 = "";
            }
            else
            {
                str5 = str5.Substring(1);
            }
            if (str6.Length > 1)
            {
                str6 = str6.Substring(1);
            }
            else
            {
                str6 = "";
            }
            if (str7.Length > 1)
            {
                str7 = str7.Substring(1);
            }
            else
            {
                str7 = "";
            }
            if (str8.Length <= 1)
            {
                str8 = "";
            }
            else
            {
                str8 = str8.Substring(1);
            }
            if (str9.Length <= 1)
            {
                str9 = "";
            }
            else
            {
                str9 = str9.Substring(1);
            }
            strSql = "update ExamUser set LastTime='" + string_4 + "',Flag='A',IsSave=0,StartTime='',EndTime='',GetOldCountFen=0,GetCountFen=0,LoginIP='' where UserCode='" + string_0 + "' and PaperID=" + string_1;
            strSql = strSql + ";update PaperData set RubricS='" + str + "',RubricD='" + str2 + "',RubricB='" + str3 + "',RubricF='" + str4 + "',RubricA='" + str5 + "',RubricC='" + str6 + "',RubricT='" + str7 + "',RubricAN='" + str8 + "',RubricO='" + str9 + "',RubricJ='" + values + "' where PaperID='" + string_1 + "' and UserCode='" + string_0 + "'";
            strSql = strSql + ";delete from CheckPaper where  UserCode='" + string_0 + "' and PaperID=" + string_1;
            this.publicFun_0.ExecuteSql(strSql);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                string strUserCode = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserCode"].ToString()));
                string str5 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserName"].ToString()));
                string password = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserPwd"].ToString()));
                string str14 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserSex"].ToString()));
                string str15 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserDeptID"].ToString()));
                string str16 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserWorker"].ToString()));
                string str12 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserAge"].ToString()));
                string str11 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserEdu"].ToString()));
                string str10 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["UserSFZH"].ToString()));
                string str8 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["JoinDate"].ToString()));
                string str9 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["MoveTel"].ToString()));
                string str7 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["GWName"].ToString()));
                string str6 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["GWLevel"].ToString()));
                string str3 = this.publicFun_0.CheckString(base.Server.UrlDecode(base.Request["IsNew"].ToString()));
                if (strUserCode.Trim() == "admin")
                {
                    strUserCode = "ａｄｍｉｎ";
                }
                if (strUserCode.Trim() != "")
                {
                    if (str5.Trim() != "")
                    {
                        if ((str3 != "Y") || (password.Trim() != ""))
                        {
                            if (str14.Trim() == "")
                            {
                                base.Response.Write("UserSex is Error");
                            }
                            else
                            {
                                if (str14.Trim() != "男")
                                {
                                    str14 = "女";
                                }
                                if (str15.Trim() != "")
                                {
                                    if (str16.Trim() != "")
                                    {
                                        if (password.Trim() != "")
                                        {
                                            password = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "MD5").Trim();
                                            if (password.Length > 20)
                                            {
                                                password = password.Substring(0, 20);
                                            }
                                        }
                                        string strSql = "";
                                        string str2 = "A";
                                        try
                                        {
                                            if (str3 == "Y")
                                            {
                                                if (this.publicFun_0.GetValues("select UserCode from UserInfo where UserCode='" + strUserCode + "'", "UserCode").Trim() != "")
                                                {
                                                    base.Response.Write("Have UserCode " + strUserCode);
                                                }
                                                else
                                                {
                                                    strSql = "Insert into UserInfo(UserCode,UserName,UserSex,UserPwd,DeptID,Worker,UserPhoto,UserLevel,Flag,StyleInfo,HandCombNO,RacingFen,HandMemo,HandImg,UserAge,JoinWorkDate,UserGWName,UserGWLevel,UserSFZH,UserEdu,UserMemo,UserFen,UserMember) values(";
                                                    strSql = (strSql + "'" + strUserCode + "','" + str5 + "','" + str14 + "','" + password + "','" + str15 + "','" + str16 + "','','A','" + str2 + "','N','" + str9 + "','-1','','','" + str12 + "','" + str8 + "','" + str7 + "','" + str6 + "','" + str10 + "','" + str11 + "','','0','1')") + ";insert into UserPower(UserCode) values('" + strUserCode + "')";
                                                    strSql = strSql + ";insert into SysLogInfo(LogDisp,EditUser,EditUserCode) values('[" + strUserCode + "]用户同步新增成功！','" + str5 + "','" + strUserCode + "')";
                                                    this.publicFun_0.ExecuteSql(strSql);
                                                    this.publicFun_0.AddUserPaper(strUserCode);
                                                    this.method_0(strUserCode);
                                                    this.publicFun_0.AddUserWorkPaper(strUserCode);
                                                    base.Response.Write("add succ");
                                                }
                                            }
                                            else if (!(str3 == "E"))
                                            {
                                                if (str3 == "D")
                                                {
                                                    strSql = "delete UserInfo  where UserCode='" + strUserCode + "';delete UserPower where  UserCode='" + strUserCode + "'";
                                                    strSql = strSql + ";insert into SysLogInfo(LogDisp,EditUser,EditUserCode) values('[" + strUserCode + "]用户同步删除成功！','" + str5 + "','" + strUserCode + "')";
                                                    this.publicFun_0.ExecuteSql(strSql);
                                                    base.Response.Write("del succ");
                                                }
                                            }
                                            else
                                            {
                                                strSql = "update UserInfo set UserName='" + str5 + "',UserSex='" + str14 + "',DeptID='" + str15 + "',Worker='" + str16 + "' ";
                                                if (password.Trim() != "")
                                                {
                                                    strSql = strSql + ",UserPwd='" + password + "'";
                                                }
                                                if (str12.Trim() != "")
                                                {
                                                    strSql = strSql + ",UserAge='" + str12 + "'";
                                                }
                                                if (str11.Trim() != "")
                                                {
                                                    strSql = strSql + ",UserEdu='" + str11 + "'";
                                                }
                                                if (str10.Trim() != "")
                                                {
                                                    strSql = strSql + ",UserSFZH='" + str10 + "'";
                                                }
                                                if (str9.Trim() != "")
                                                {
                                                    strSql = strSql + ",HandMemo='" + str9 + "'";
                                                }
                                                if (str8.Trim() != "")
                                                {
                                                    strSql = strSql + ",JoinWorkDate='" + str8 + "'";
                                                }
                                                if (str7.Trim() != "")
                                                {
                                                    strSql = strSql + ",UserGWName='" + str7 + "'";
                                                }
                                                if (str6.Trim() != "")
                                                {
                                                    strSql = strSql + ",UserGWLevel='" + str6 + "'";
                                                }
                                                strSql = strSql + " where UserCode='" + strUserCode + "'";
                                                strSql = strSql + ";insert into SysLogInfo(LogDisp,EditUser,EditUserCode) values('[" + strUserCode + "]用户同步修改成功！','" + str5 + "','" + strUserCode + "')";
                                                this.publicFun_0.ExecuteSql(strSql);
                                                base.Response.Write("edit succ");
                                            }
                                        }
                                        catch
                                        {
                                            base.Response.Write("Register UserInfo is Error");
                                        }
                                    }
                                    else
                                    {
                                        base.Response.Write("UserWorker is Error");
                                    }
                                }
                                else
                                {
                                    base.Response.Write("UserDeptID is Error");
                                }
                            }
                        }
                        else
                        {
                            base.Response.Write("UserPwd is Error");
                        }
                    }
                    else
                    {
                        base.Response.Write("UserName is Error");
                    }
                }
                else
                {
                    base.Response.Write("UserCode is Error");
                }
            }
        }
    }
}

